/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : localhost
 Source Database       : buct_gard

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : utf-8

 Date: 07/19/2016 01:48:06 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `building`
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building` (
  `building_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '楼宇编号',
  `building_name` varchar(128) DEFAULT NULL COMMENT '楼宇名字',
  PRIMARY KEY (`building_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `building`
-- ----------------------------
BEGIN;
INSERT INTO `building` VALUES ('1', '主教'), ('2', '电教'), ('3', '科教');
COMMIT;

-- ----------------------------
--  Table structure for `car`
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_car_id` varchar(128) NOT NULL COMMENT '机动车申请编号',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态（1待审核2已通过3未通过）',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注，理由',
  `staff_id` int(10) NOT NULL COMMENT '教职工工号',
  `car_type` tinyint(1) DEFAULT NULL COMMENT '车证类型1代表通行证2代表停车证',
  `owner_name` varchar(48) DEFAULT NULL COMMENT '所有人名字',
  `owner_add` varchar(255) DEFAULT NULL COMMENT '所有人地址',
  `relation` tinyint(1) DEFAULT NULL COMMENT '与车主关系1代表本人2代表夫妻',
  `brand` varchar(255) DEFAULT NULL COMMENT '品牌',
  `color` varchar(255) DEFAULT NULL COMMENT '颜色',
  `car_photo` varchar(255) DEFAULT NULL COMMENT '车照片',
  `xingshi_license` varchar(255) DEFAULT NULL COMMENT '行驶证照片',
  `jiashi_license` varchar(255) DEFAULT NULL COMMENT '驾驶证照片',
  `plate_number` varchar(20) DEFAULT NULL COMMENT '车牌号',
  `read` int(1) DEFAULT NULL COMMENT '是否已读，1代表已读，2代表未读',
  `is_drift` tinyint(1) DEFAULT '1' COMMENT '是否为草稿，1不是草稿，2草稿',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `car`
-- ----------------------------
BEGIN;
INSERT INTO `car` VALUES ('3', '20160516002023', '2016-05-16 00:20:23', '1', '', '2012014379', '1', '吴', '北京', '1', '奔驰', '白色', '', '', '', '321', null, '1'), ('4', '20160516005834', '2016-05-16 00:58:34', '2', '', '2012014379', '1', '李', '上海', '1', '奥地利', '红色', '', '', '', '212', null, '1'), ('10', '20160516080135', '2016-05-16 08:01:35', '3', '不行', '2012014379', '1', '吴阿鹏', '北京化工大学', '2', '奥迪', '红色', '', '', '', '21123', null, '1'), ('12', '20160518213823', '2016-05-18 21:38:23', '2', '', '2012014379', '0', '陈', '新建', '0', '', '', '', '', '', '', null, '1'), ('13', '20160518220925', '2016-05-18 22:09:25', '3', '驳回', '2012014379', '0', '孟', '海南呢', '1', '绿色', '范德萨发', '', '', '', '11111', null, '1'), ('14', '20160518225721', '2016-05-18 22:57:21', '3', '', '2012014379', '2', '许', 'ffdsf', '1', 'fds', 'fdsfssdf', '', '', '', 'fdsfss', null, '1'), ('15', '20160522203209', '2016-05-22 20:32:09', '2', '批准', '2012014379', '1', 'SD', 'DSA', '1', 'DSA', 'DAS', '', '', '', 'DSADA', null, '1'), ('16', '20160528103408', '2016-05-28 10:34:08', '1', '', '2012014379', '1', '奥巴马', '美国', '2', '奥迪', '白色', '', '', '', '123', null, '1'), ('17', '20160528122303', '2016-05-28 12:23:03', '1', '', '2012014379', '1', '12', '12', '1', '12', '12', '', '', '', '12', null, '1'), ('18', '20160611215716', '2016-06-11 21:57:16', '1', '', '2012014379', '1', 'dasdas', 'dsadsa', '1', 'dsad', 'dsada', '', '', '', '123123123', null, '1'), ('19', '20160611220005', '2016-06-11 22:00:05', '1', '', '2012014379', '1', 'dsa', 'dsadsa', '2', 'dsad', 'dsa', '', '', '', '123141241', null, '1'), ('20', '20160611220523', '2016-06-11 22:05:23', '1', '', '2012014379', '1', 'dsad', 'dsadas', '1', 'dsadasdas', 'dasdasdas', '201606112016-06-11/575c1aa3de56f.jpg', '201606112016-06-11/575c1aa3de56f.jpg', '201606112016-06-11/575c1aa3de56f.jpg', '213123124312', null, '1'), ('21', '20160611221012', '2016-06-11 22:10:12', '1', '', '2012014379', '2', 'dsa', 'dsadas', '2', 'dsadas', 'dsadas', '2016-06-11/575c1bc43385c.jpg', '2016-06-11/575c1bc43385c.jpg', '2016-06-11/575c1bc43385c.jpg', '12321312', null, '1'), ('22', '20160617190737', '2016-06-17 19:07:37', '1', '', '2012014379', '1', 'dsad', 'dsa', '2', 'das', 'das', '2016-06-17/5763d9f9ba061.jpg', '2016-06-17/5763d9f9ba061.jpg', '2016-06-17/5763d9f9ba061.jpg', '3213123', null, '1'), ('23', '20160618112027', '2016-06-18 11:20:27', '3', '驳回', '2012014377', '1', '姓名', '地址', '2', '23', 'dasd', '2016-06-18/5764bdfb19f9d.jpg', '2016-06-18/5764bdfb19f9d.jpg', '2016-06-18/5764bdfb19f9d.jpg', '2131fsd', null, '1'), ('24', '20160618143344', '2016-06-18 14:33:44', '1', '', '2012014377', '1', '4314', '432', '1', '432', '432', '2016-06-18/5764eb484430d.jpg', '2016-06-18/5764eb484430d.jpg', '2016-06-18/5764eb484430d.jpg', '2e1edsa', null, '2'), ('25', '20160618145634', '2016-06-18 14:56:34', '1', '', '2012014377', '1', '俄武器2', '21', '1', '2241dsa', 'dasds 啊', '2016-06-18/5764f0a258bfa.jpg', '2016-06-18/5764f0a258bfa.jpg', '2016-06-18/5764f0a258bfa.jpg', '1231432', null, '2'), ('26', '20160618145854', '2016-06-18 14:58:54', '1', '', '2012014377', '1', '321', '321', '1', '312', '321', '2016-06-18/5764f12eac716.jpg', '2016-06-18/5764f12eac716.jpg', '2016-06-18/5764f12eac716.jpg', '31231', null, '2'), ('27', '20160618185817', '2016-06-18 18:58:17', '1', '', '2012014376', '1', 'cdscds', 'cdscd', '1', 'scsdc', 'csdcsd', '2016-06-18/576529495ecc9.png', '2016-06-18/576529495ecc9.png', '2016-06-18/576529495ecc9.png', 'ddsfdsafds', null, '1'), ('28', '20160624151935', '2016-06-24 15:19:35', '1', '', '2012014377', '1', '姓名', '地址', '2', '品牌', '颜色', '2016-06-24/576cdf07dc122.png', '2016-06-24/576cdf07dc122.png', '2016-06-24/576cdf07dc122.png', '1234MK', null, '1'), ('29', '20160626233735', '2016-06-26 23:37:35', '1', '', '2012014376', '1', 'linxiapyong', 'address', '2', 'pinpai', 'yanse', '2016-06-26/576ff6bf45bd3.jpg', '2016-06-26/576ff6bf52fcd.jpg', '2016-06-26/576ff6bf569f6.jpg', 'haoma123', null, '1'), ('30', '20160626234303', '2016-06-26 23:43:03', '1', '', '2012014376', '1', '2133', '31231', '1', '31241', '1241', '2016-06-26/576ff8070db02.jpg', '2016-06-26/576ff80713927.jpg', '2016-06-26/576ff8071a44e.jpg', '21sa', null, '1'), ('31', '20160626234725', '2016-06-26 23:47:25', '1', '', '2012014376', '2', 'sadsa', 'dsadas', '1', 'dsa', 'dsa', '2016-06-26/576ff90d362e6.jpg', '2016-06-26/576ff90d3d8c5.jpg', '2016-06-26/576ff90d44058.jpg', 'sada1123', null, '2'), ('32', '20160626235054', '2016-06-26 23:50:54', '1', '', '2012014377', '2', 'yuyu', '898988', '1', '898989', '8999889', '2016-06-26/576ff9de6de5a.png', '2016-06-26/576ff9de6ff28.png', '2016-06-26/576ff9de79722.gif', '89889898', null, '1'), ('33', '20160719014404', '2016-07-19 01:44:04', '1', '', '2012014376', '0', '', '', '0', '', '', '2016-07-19/578d1564007a8.png', '2016-07-19/578d156401115.png', '2016-07-19/578d156401612.png', '宁A125301111', null, '1'), ('34', '20160719014517', '2016-07-19 01:45:17', '1', '', '2012014376', '0', '', '', '0', '', '', '2016-07-19/578d15ad2585d.png', '2016-07-19/578d15ad25abe.png', '2016-07-19/578d15ad25ce1.png', '宁A12530', null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `check`
-- ----------------------------
DROP TABLE IF EXISTS `check`;
CREATE TABLE `check` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_check_id` varchar(128) NOT NULL COMMENT '安全检查编号',
  `room_id` varchar(128) NOT NULL COMMENT '检查单位编号',
  `check_content` varchar(255) DEFAULT NULL COMMENT '检查内容',
  `check_time` int(12) DEFAULT NULL COMMENT '检查时间',
  `status` int(1) DEFAULT NULL COMMENT '状态  3代表待整改 2代表已整改  1 代表已通过',
  `remark` varchar(255) DEFAULT NULL COMMENT '保卫处邮件备注',
  `read` int(1) DEFAULT NULL COMMENT '是否已读，1代表已读，2代表未读',
  `is_check` int(1) DEFAULT '3' COMMENT '状态  3代表待整改 2代表已整改  1 代表已通过',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `check`
-- ----------------------------
BEGIN;
INSERT INTO `check` VALUES ('1', '20160712232758', '1', 'zhenggai', '1468337265', '3', null, '2', '2'), ('2', '20160712233341', '2', 'zhengai', '1468337613', '1', null, '2', '2'), ('3', '20160713002318', '2', 'zhenggai', '1468340584', '1', 'tongyi', '2', '1'), ('4', '20160713004338', '0', 'zhengai', '1468341783', '3', '', '2', '3'), ('5', '20160713004459', '1', 'dasdasd', '1468341895', '1', 'tongyi', '2', '1');
COMMIT;

-- ----------------------------
--  Table structure for `fire`
-- ----------------------------
DROP TABLE IF EXISTS `fire`;
CREATE TABLE `fire` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消防器材申请编号',
  `tab_fire_id` varchar(128) NOT NULL COMMENT '消防器材申请编号',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态（1待审核2已通过3未通过）',
  `remark` varchar(255) DEFAULT NULL COMMENT '保卫处备注，理由',
  `staff_id` int(10) NOT NULL COMMENT '教职工编号',
  `apply_unit` varchar(128) DEFAULT NULL COMMENT '申请单位',
  `apply_content` varchar(255) DEFAULT NULL COMMENT '配置申请内容',
  `powder_amount` int(5) DEFAULT NULL COMMENT '干粉数量',
  `powder_location` varchar(128) DEFAULT NULL COMMENT '干粉配置地点',
  `powder_configure` datetime DEFAULT NULL COMMENT '干粉配置时间',
  `powder_repair` datetime DEFAULT NULL COMMENT '干粉维修时间',
  `carbon_amount` int(5) DEFAULT NULL COMMENT '二氧化碳数量',
  `carbon_location` varchar(128) DEFAULT NULL COMMENT '二氧化碳配置地点',
  `carbon_configure` datetime DEFAULT NULL COMMENT '二氧化碳配置时间',
  `carbon_repair` datetime DEFAULT NULL COMMENT '二氧化碳维修时间',
  `blanket_amount` int(5) DEFAULT NULL COMMENT '灭火毯数量',
  `blanket_location` varchar(255) DEFAULT NULL COMMENT '灭火毯配置地点',
  `blanket_configure` datetime DEFAULT NULL COMMENT '灭火毯配置时间',
  `extinguisher_amount` int(5) DEFAULT NULL COMMENT '灭火箱数量',
  `extinguisher_location` varchar(255) DEFAULT NULL COMMENT '灭火箱配置地点',
  `extinguisher_cofigure` datetime DEFAULT NULL COMMENT '灭火箱配置时间',
  `read` int(1) DEFAULT NULL COMMENT '是否已读，1代表已读，2代表未读',
  `is_drift` tinyint(1) DEFAULT '1' COMMENT '是否为草稿，1不是草稿，2草稿',
  `is_apply` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `fire`
-- ----------------------------
BEGIN;
INSERT INTO `fire` VALUES ('1', '20160713014104', '2016-07-13 01:41:04', '1', '', '2012014376', '信息学院', 'aaaa', '12', '', '2016-07-13 01:41:04', '2016-07-13 01:41:04', '23', '', '2016-07-13 01:41:04', '2016-07-13 01:41:04', '12', '', '2016-07-13 01:41:04', '23', '', '2016-07-13 01:41:04', null, '1', '1'), ('2', '20160713024931', '2016-07-13 02:49:31', '1', '', '2012014376', 'dsadasd', 'dsadasdas', '1', '', '2016-07-13 02:49:31', '2016-07-13 02:49:31', '2', '', '2016-07-13 02:49:31', '2016-07-13 02:49:31', '3', '', '2016-07-13 02:49:31', '5', '', '2016-07-13 02:49:31', null, '1', '1'), ('3', '20160713030231', '2016-07-13 03:02:31', '1', '', '2012014377', 'dsa', 'dsad', '13', '', '2016-07-13 00:00:00', '2016-07-13 00:00:00', '25', '', '2016-07-13 00:00:00', '2016-07-13 00:00:00', '23', '', '2016-07-13 00:00:00', '23', '', '2016-07-13 00:00:00', null, '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `permit`
-- ----------------------------
DROP TABLE IF EXISTS `permit`;
CREATE TABLE `permit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tab_permit_id` varchar(128) NOT NULL COMMENT '动火证申请编号',
  `apply_time` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL COMMENT '状态 1待审核  2已通过  3未通过',
  `remark` varchar(255) DEFAULT NULL COMMENT '邮件备注',
  `staff_id` int(10) NOT NULL,
  `apply_name` varchar(255) DEFAULT NULL COMMENT '申请动火的校内单位名称',
  `apply_incharge` varchar(128) DEFAULT NULL COMMENT '申请动火单位负责人',
  `construct_name` varchar(255) DEFAULT NULL COMMENT '施工单位名称',
  `construct_incharge` varchar(128) DEFAULT NULL COMMENT '施工单位负责人',
  `special_cer` int(1) DEFAULT NULL COMMENT '特种操作作业证，1代表有，2代表没有',
  `special_id` varchar(128) DEFAULT NULL COMMENT '特种作业操作证证件号码',
  `special_time` datetime DEFAULT NULL COMMENT '特种作业操作证有效期时间',
  `operator_name` varchar(128) DEFAULT NULL COMMENT '动火操作人员',
  `operator_reason` varchar(255) DEFAULT NULL COMMENT '动火操作原因',
  `operator_localtion` varchar(255) DEFAULT NULL COMMENT '动火操作部位及环境',
  `operator_photo` varchar(255) DEFAULT NULL COMMENT '施工方案图',
  `operator_type` varchar(128) DEFAULT NULL COMMENT '动火操作类型',
  `operator_starttime` datetime DEFAULT NULL COMMENT '动火操作开始时间',
  `operator_endtime` datetime DEFAULT NULL COMMENT '动火操作结束时间',
  `operator_measure` varchar(255) DEFAULT NULL COMMENT '动火操作采取的安全措施',
  `read` int(1) DEFAULT NULL COMMENT '是否已读，1代表已读，2代表未读',
  `is_drift` tinyint(1) DEFAULT '1' COMMENT '是否为草稿，1不是草稿，2草稿',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `permit`
-- ----------------------------
BEGIN;
INSERT INTO `permit` VALUES ('1', '20160516084211', '2016-05-16 08:42:11', '3', '不可以', '2012014377', 'fsd', 'fdsf', 'fdsf', 'fds', '2', '', '2016-05-16 08:42:11', 'fsdsf', 'fdsfs', 'fdsfs', '', 'fsdsdf', '2016-05-16 08:42:11', '2016-05-16 08:42:11', 'fdssf', null, '1'), ('2', '20160516085027', '2016-05-16 08:50:27', '2', '', '2012014377', 'fdsa', 'fsdfsd', 'fdsfsd', 'fdsf', '2', '', '2016-05-16 08:50:27', '', '', '', '', '', '2016-05-16 08:50:27', '2016-05-16 08:50:27', '', null, '1'), ('3', '20160518232014', '2016-05-18 23:20:14', '3', '', '2012014379', 'aaaaaaaaaaaa', 'aaaaaaaaaaaa', 'aaaaaaaaaaaa', 'aaaaaaaaaaaa', '2', '', '2016-05-18 23:20:14', 'aaaaaaaaaaaa', 'aaaaaaaaaaaa', 'aaaaaaaaaaaa', '', 'aaaaaaaaaaaa', '2016-05-18 23:20:14', '2016-05-18 23:20:14', 'aaaaaaaaaaaa', null, '1'), ('4', '20160518232850', '2016-05-18 23:28:50', '3', '', '2012014379', 'bbbbbbb', 'bbbbbbb', 'bbbbbbb', 'bbbbbbb', '2', '', '2016-05-18 23:28:50', 'bbbbbbb', 'bbbbbbb', 'bbbbbbb', '', 'bbbbbbb', '2016-05-18 23:28:50', '2016-05-18 23:28:50', 'bbbbbbb', null, '1'), ('5', '20160529101211', '2016-05-29 10:12:11', '2', '可以', '2012014379', '111111111111111111', '111111111111111111', '111111111111111111', '111111111111111111', '2', '', '2016-05-29 10:12:11', '111111111111111111', '111111111111111111', '111111111111111111', '', '111111111111111111', '2016-05-29 10:12:11', '2016-05-29 10:12:11', '111111111111111111', null, '1'), ('6', '20160705155657', '2016-07-05 19:12:59', '1', '', '2012014377', 'ca', 'ca', 'ca', 'ca', '1', 'ca', '2016-07-05 15:56:39', 'ca', 'ca', 'ca', '2016-07-05/577b963b91403.png', 'ca', '2016-07-05 19:12:59', '2016-07-05 15:56:39', 'ca', null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `purview`
-- ----------------------------
DROP TABLE IF EXISTS `purview`;
CREATE TABLE `purview` (
  `purview_id` int(11) NOT NULL,
  `purview_url` varchar(128) NOT NULL,
  `purview_name` varchar(128) DEFAULT NULL,
  `purview_desc` varchar(32) NOT NULL DEFAULT 'index',
  `del` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`purview_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `purview`
-- ----------------------------
BEGIN;
INSERT INTO `purview` VALUES ('1', 'admin/check/index', '安全检查', '安全检查', '1');
COMMIT;

-- ----------------------------
--  Table structure for `report`
-- ----------------------------
DROP TABLE IF EXISTS `report`;
CREATE TABLE `report` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL COMMENT '接案人',
  `informant` varchar(128) DEFAULT NULL COMMENT '报案人',
  `id_card` char(18) DEFAULT NULL COMMENT '身份证号',
  `phone` varchar(32) DEFAULT NULL COMMENT '电话号码',
  `unit` varchar(48) DEFAULT NULL COMMENT '单位',
  `address` varchar(128) DEFAULT NULL,
  `happen_place` varchar(128) DEFAULT NULL,
  `report_time` int(12) DEFAULT NULL,
  `happen_stime` int(12) DEFAULT NULL COMMENT '案发开始时间',
  `happen_etime` int(12) DEFAULT NULL COMMENT '案截至发时间',
  `happen_content` text,
  `status` tinyint(2) DEFAULT NULL COMMENT '1未结案，2已结案',
  `extern` text,
  `reg_time` int(12) DEFAULT NULL,
  `del` tinyint(4) DEFAULT NULL COMMENT '1正常，2删除',
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `report`
-- ----------------------------
BEGIN;
INSERT INTO `report` VALUES ('1', '2012014379', 'maqun', '621790001000342344', '432432423423', '北京化工大学', '北京化工大学', '北京化工大学', '1466007898', '1467217500', '1467217501', '案发经过案发经过案发经过案发经过案发经过案发经过', '1', '损失情况，失物名称及特征，估计价值', '1464971157', '1'), ('2', '2012014379', 'aaaaa', '1231321412341', '4124132413', '4214134', '4124124', '1241412', '1467218442', '1465404046', '1465922447', '4124141414', '2', 'dfsfsdfsdfsdfdsfsdfsdf', '1464972053', '1'), ('3', '2012014379', '', '', '', '', '', '', '1466747699', '1466747699', '1466747699', '', '1', '', '1466747713', '1'), ('4', '2012014379', '主教503', '', '', '', '', '', '1468136336', '1468136336', '1468136336', '', '1', '', '1468136336', '1');
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色编号',
  `role_name` varchar(128) DEFAULT NULL COMMENT '角色名',
  `purview_id` varchar(255) DEFAULT NULL COMMENT '权限',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('1', '保卫处管理员', '1,2,3,4,5,6,7,8,9'), ('2', '保卫处监控员', '1,2,3,4,5,6,7,8,9,10'), ('3', '学院领导', '1,2,3,4,5,6,7,8,9,10'), ('4', '普通教职工', null);
COMMIT;

-- ----------------------------
--  Table structure for `room`
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` varchar(32) DEFAULT NULL COMMENT '房间编号',
  `room_name` varchar(255) DEFAULT NULL COMMENT '房间名字',
  `staff_id` int(10) DEFAULT NULL COMMENT '教职工编号',
  `powder_amount` int(5) DEFAULT NULL COMMENT '干粉数量',
  `carbon_amount` int(5) DEFAULT NULL COMMENT '二氧化碳数量',
  `blanket_amount` int(5) DEFAULT NULL COMMENT '灭火毯数量',
  `extinguisher_amount` int(5) DEFAULT NULL COMMENT '灭火器数量',
  `building_id` int(11) NOT NULL COMMENT '楼宇编号（关联楼宇表）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `room`
-- ----------------------------
BEGIN;
INSERT INTO `room` VALUES ('1', '1', 'room1', '2012014377', '12', '12', '23', '32', '32'), ('2', '2', 'room2', '2012014377', '12', '121', '321', '3123', '321'), ('3', 'room_20160710154641', '', '0', '0', '0', '0', '0', '1'), ('4', 'room_20160710154939', '主教502', '0', '0', '0', '0', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `staff`
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `staff_id` int(10) NOT NULL COMMENT '教职工编号',
  `password` varchar(128) DEFAULT NULL COMMENT '密码',
  `staff_name` varchar(48) DEFAULT NULL COMMENT '教职工名字',
  `staff_unit` varchar(128) DEFAULT NULL COMMENT '教职工单位',
  `staff_tel` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `staff_email` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `staff_ins` varchar(128) DEFAULT NULL COMMENT '所属院系',
  `role_id` int(11) NOT NULL COMMENT '角色编号（关联角色表）',
  `is_admin_user` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否为后台用户，是为1，不是为2',
  `rooms` varchar(4086) DEFAULT NULL,
  `tmgrs` int(11) DEFAULT '0',
  `mulit_role` tinyint(2) DEFAULT '1',
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `staff`
-- ----------------------------
BEGIN;
INSERT INTO `staff` VALUES ('2012', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员', null, null, null, null, '5', '1', null, '0', '1'), ('2012014376', 'e10adc3949ba59abbe56e057f20f883e', '林晓勇s', '信息学院201', '15609876789', '345@qq.com', '信息学院', '4', '2', '1|2|3|4', '2012014377', '1'), ('2012014377', 'e10adc3949ba59abbe56e057f20f883e', '朱群雄', '信息学院101', '643874387', 'cdsc', '信息学院', '3', '2', null, '0', '1'), ('2012014378', 'e10adc3949ba59abbe56e057f20f883e', '李监控', '保卫处', '010-3677889', '123@qq.com', '无', '2', '1', null, '0', '1'), ('2012014380', 'e10adc3949ba59abbe56e057f20f883e', '王管理', '保卫处', '010-8908987', '234@qq.com', '无', '1', '1', null, '0', '1'), ('2012014381', 'e10adc3949ba59abbe56e057f20f883e', '123456', 'qwe', '13223224322', 'ewqewq@163.com', 'ewq', '1', '1', null, '0', '1'), ('2012014390', '123456', '王管理', '保卫处', '010-8908987', '234@qq.com', '无', '1', '1', null, '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `video`
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
